Overview: Delay

Use this operation to create a dataset with delayed data values for selected fields. These delays can be implemented on either the row number (index based) or as a number of seconds (time based). Multiple fields can be delayed, each by different values.

Index based delay:

  • The values of the selected fields will be shifted down the configured number of rows.

  • Your dataset will increase by the configured number of rows for the delay.

  • If you have 10 rows in your dataset for a specific field and you add a delay of 2 rows, your resulting dataset will have 12 rows, where the first 2 rows will have null values.

Time based delay:

  • Every timestamp will be delayed by your configured delay.

  • Your dataset will increase by the total configured number of timestamp delays, for each different field.  

  • The values of the rows before the delayed value will be null.

Properties

Category:

Transform

Performance risk:

High potential performance risk. The performance is influenced by the size of the text file being imported, which is determined by number of rows and/or the number of columns of the dataset.

Knowledge required:

Working knowledge of the software.

 

Effect on datasets

How many datasets are required to perform this operation?

One

Does it create a new dataset?

Yes

Can you reconfigure this operation?

Yes

Can you apply this operation to a locked dataset?

Yes

Does it modify the current dataset in any way?

No

Requirements

  • A dataset with at least one field of any type.

Results

  • The resulting dataset will contain only the configured dataset fields with their values shifted to the new delayed position.

  • Rows preceding the delayed value will have null values.

  • Values to be delayed can either be interpolated or remain constant at the previous value.


Related topics:

  

CSense 2023- Last updated: June 24,2025